{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 处理百融重复信息"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "2个成功 ----取竣工的，都竣工取时间最新 <br>\n",
    "2个失败 ----取时间最新的 <br>\n",
    "1个成功1个失败 ----   <br>\n",
    "成功失败分开处理重复，然后合并到一起处理一个成功一个失败的<br>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-18T06:58:31.995264Z",
     "start_time": "2019-09-18T06:58:31.901506Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MOBILE_NO</th>\n",
       "      <th>ACCOUNT_ID</th>\n",
       "      <th>CUSTOMER_NAME</th>\n",
       "      <th>CERT_NO_CIPHERTEXT</th>\n",
       "      <th>征信表拒绝原因</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ZIYINGB_SCORE</th>\n",
       "      <th>腾讯分</th>\n",
       "      <th>运营商</th>\n",
       "      <th>三月消费</th>\n",
       "      <th>入网时长</th>\n",
       "      <th>百融分</th>\n",
       "      <th>授信状态</th>\n",
       "      <th>授信拒绝原因</th>\n",
       "      <th>CITY_NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>15351791350</td>\n",
       "      <td>20190918084526113656</td>\n",
       "      <td>雍志强</td>\n",
       "      <td>3632694963464569762F5738433541353256524D457A64...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>35.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>580.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13634714237</td>\n",
       "      <td>20190918090148113883</td>\n",
       "      <td>李洁</td>\n",
       "      <td>31394457767032574A65444536373847324D564A304266...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>619</td>\n",
       "      <td>56.0</td>\n",
       "      <td>M</td>\n",
       "      <td>175.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>619.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>呼和浩特市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18996059211</td>\n",
       "      <td>20190918090520114056</td>\n",
       "      <td>陈世伟</td>\n",
       "      <td>67594C3344747044715A59733254327264656844614679...</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>482</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>482.0</td>\n",
       "      <td>3</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17715633993</td>\n",
       "      <td>20190918093155115069</td>\n",
       "      <td>邹红林</td>\n",
       "      <td>2F477158775448774A4276526647387173346761487454...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>594</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>160.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>594.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17758009151</td>\n",
       "      <td>20190918093528114978</td>\n",
       "      <td>施小东</td>\n",
       "      <td>776B424F55554D4A55582F5349753136456D7056365831...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>464</td>\n",
       "      <td>39.0</td>\n",
       "      <td>T</td>\n",
       "      <td>20.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>464.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杭州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>18933367633</td>\n",
       "      <td>20190918093635115203</td>\n",
       "      <td>严敏强</td>\n",
       "      <td>4D774E35694B57355A36656B32613152512B2F3632366B...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>586</td>\n",
       "      <td>24.0</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>586.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15700118010</td>\n",
       "      <td>20190918094402115544</td>\n",
       "      <td>向东</td>\n",
       "      <td>704361552F2B376854746C336A326D6953705346347865...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>555</td>\n",
       "      <td>32.0</td>\n",
       "      <td>M</td>\n",
       "      <td>175.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>555.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杭州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>18108084837</td>\n",
       "      <td>20190918101455117157</td>\n",
       "      <td>彭怀</td>\n",
       "      <td>7A70336E5553474D4B59677677573669663569424D2B4D...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>536</td>\n",
       "      <td>20.0</td>\n",
       "      <td>T</td>\n",
       "      <td>160.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>536.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>成都市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>18683090162</td>\n",
       "      <td>20190918102119117811</td>\n",
       "      <td>陈利金</td>\n",
       "      <td>7848506E41304B7359553355584E77552B5534396C7551...</td>\n",
       "      <td>运营商为联通且身份证关联的邮箱个数大于等于0且1个月内在非银机构新增核准借贷次数大于等于1</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>U</td>\n",
       "      <td>120.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>491.0</td>\n",
       "      <td>3</td>\n",
       "      <td>运营商为联通且身份证关联的邮箱个数大于等于0且1个月内在非银机构新增核准借贷次数大于等于1</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17502520729</td>\n",
       "      <td>20190918142108130933</td>\n",
       "      <td>卞九华</td>\n",
       "      <td>6C78656738726D6534306D6E426C55737A6777754D6145...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>554</td>\n",
       "      <td>26.0</td>\n",
       "      <td>U</td>\n",
       "      <td>120.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>554.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>南京市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>18305211899</td>\n",
       "      <td>20190918143826132052</td>\n",
       "      <td>张飞</td>\n",
       "      <td>482B784B66732B325A6A44567A626B3759524F596B3578...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>616</td>\n",
       "      <td>26.0</td>\n",
       "      <td>M</td>\n",
       "      <td>225.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>616.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>13376069955</td>\n",
       "      <td>20190918144353132343</td>\n",
       "      <td>张晓露</td>\n",
       "      <td>6E6774556A2B483754713269424F597939414974397935...</td>\n",
       "      <td>入网时长为空，三月消费金额为空</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>655</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>655.0</td>\n",
       "      <td>3</td>\n",
       "      <td>入网时长为空，三月消费金额为空</td>\n",
       "      <td>南京市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>18842551905</td>\n",
       "      <td>20190918112358122026</td>\n",
       "      <td>赵小燕</td>\n",
       "      <td>596243434467516B392B7161586D55513030736C577770...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>497</td>\n",
       "      <td>22.0</td>\n",
       "      <td>M</td>\n",
       "      <td>225.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>497.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈阳市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>15330338987</td>\n",
       "      <td>20190918112900122182</td>\n",
       "      <td>张望</td>\n",
       "      <td>2B374F6D4B7268624557632B5737746438776D6E6C2F2F...</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>581</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>160.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>581.0</td>\n",
       "      <td>3</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>18048335709</td>\n",
       "      <td>20190918113406122503</td>\n",
       "      <td>郭利光</td>\n",
       "      <td>7442496B5752552F6974335130355A4E6D32634132764D...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>553</td>\n",
       "      <td>56.0</td>\n",
       "      <td>T</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>553.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>呼和浩特市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>19936035059</td>\n",
       "      <td>20190918114341123232</td>\n",
       "      <td>黄新雨</td>\n",
       "      <td>35573378486D37696F684B6F774849566173622B77746D...</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>579.0</td>\n",
       "      <td>3</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>15145936023</td>\n",
       "      <td>20190918114719123507</td>\n",
       "      <td>陶国成</td>\n",
       "      <td>473945594B4A2B34356C6A524E362F647772384A316238...</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>529</td>\n",
       "      <td>33.0</td>\n",
       "      <td>M</td>\n",
       "      <td>75.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>529.0</td>\n",
       "      <td>3</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18027005790</td>\n",
       "      <td>20190918114728123512</td>\n",
       "      <td>晏松</td>\n",
       "      <td>50513675545037366F59417232392B70356F4637376C47...</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>560</td>\n",
       "      <td>36.0</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>560.0</td>\n",
       "      <td>3</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>13999904862</td>\n",
       "      <td>20190918115001123663</td>\n",
       "      <td>罗荣</td>\n",
       "      <td>31344172347243416A63587A45547243636E6E342F5666...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>683</td>\n",
       "      <td>39.0</td>\n",
       "      <td>M</td>\n",
       "      <td>175.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>683.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>乌鲁木齐市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>13464174933</td>\n",
       "      <td>20190918120330124469</td>\n",
       "      <td>牛佳音</td>\n",
       "      <td>502F6D4D5054595975482F6A636F7A5A6D2F5A6F4D4C73...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>551</td>\n",
       "      <td>21.0</td>\n",
       "      <td>M</td>\n",
       "      <td>75.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>551.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈阳市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>15895974126</td>\n",
       "      <td>20190918120440124666</td>\n",
       "      <td>胡春梅</td>\n",
       "      <td>757073386C5965502F5957614447534F4B30686B52754F...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>749</td>\n",
       "      <td>30.0</td>\n",
       "      <td>M</td>\n",
       "      <td>125.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>749.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>南京市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>15927391923</td>\n",
       "      <td>20190918123923126292</td>\n",
       "      <td>高玉红</td>\n",
       "      <td>356F51456B6874455A49494F6D416F4755616337336543...</td>\n",
       "      <td>人脸比对失败</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>551</td>\n",
       "      <td>36.0</td>\n",
       "      <td>M</td>\n",
       "      <td>175.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>551.0</td>\n",
       "      <td>3</td>\n",
       "      <td>人脸比对失败</td>\n",
       "      <td>武汉市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>17351890057</td>\n",
       "      <td>20190918124703126647</td>\n",
       "      <td>胡楚成</td>\n",
       "      <td>3632694963464569762F5734492F69466879436266656E...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>553</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>20.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>553.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>16602766657</td>\n",
       "      <td>20190918124729126801</td>\n",
       "      <td>李鹏</td>\n",
       "      <td>39565455447467737533342F4B385047677A6868737874...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>563</td>\n",
       "      <td>43.0</td>\n",
       "      <td>U</td>\n",
       "      <td>120.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>563.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>武汉市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>17362934229</td>\n",
       "      <td>20190918125354126795</td>\n",
       "      <td>李磊</td>\n",
       "      <td>426B636A687A676963455769554166536974614D726676...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>519</td>\n",
       "      <td>37.0</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>519.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>武汉市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>13914885625</td>\n",
       "      <td>20190918130906127693</td>\n",
       "      <td>毛恒</td>\n",
       "      <td>757073386C5965502F5955447964467542627165724C36...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>403</td>\n",
       "      <td>57.0</td>\n",
       "      <td>M</td>\n",
       "      <td>125.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>403.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>18064049355</td>\n",
       "      <td>20190918130940127537</td>\n",
       "      <td>黄小东</td>\n",
       "      <td>6F766E6548796C6A324B7167646145463555754E646256...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>441</td>\n",
       "      <td>21.0</td>\n",
       "      <td>T</td>\n",
       "      <td>35.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>441.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>武汉市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>18651609002</td>\n",
       "      <td>20190918132450128466</td>\n",
       "      <td>陈甜</td>\n",
       "      <td>73614C74534D6E6B672F516F4F4A566169785834453955...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>735</td>\n",
       "      <td>16.0</td>\n",
       "      <td>U</td>\n",
       "      <td>120.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>南京市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>18182288490</td>\n",
       "      <td>20190918133416128872</td>\n",
       "      <td>李中杨</td>\n",
       "      <td>4E504E65425A75636C655458462B545264675233495170...</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>519</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>519.0</td>\n",
       "      <td>3</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>13771093789</td>\n",
       "      <td>20190918134052129223</td>\n",
       "      <td>杨世威</td>\n",
       "      <td>543338646E54674D31746E57436541726E4A3931745332...</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>539</td>\n",
       "      <td>29.0</td>\n",
       "      <td>M</td>\n",
       "      <td>225.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>539.0</td>\n",
       "      <td>3</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>17318278065</td>\n",
       "      <td>20190918111853121706</td>\n",
       "      <td>朱才敏</td>\n",
       "      <td>584957376F41566932333075786452753047465754567A...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>35.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>15251492958</td>\n",
       "      <td>20190918094919115913</td>\n",
       "      <td>张芹莉</td>\n",
       "      <td>43596C6C4E5845336E6A6356744F75773373463553332F...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>M</td>\n",
       "      <td>75.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>17764582897</td>\n",
       "      <td>20190918123559126118</td>\n",
       "      <td>付鑫武</td>\n",
       "      <td>6137587A4A422B697574763643675963436A61434B7632...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>621</td>\n",
       "      <td>58.0</td>\n",
       "      <td>T</td>\n",
       "      <td>0.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杭州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>17372946662</td>\n",
       "      <td>20190918143456131876</td>\n",
       "      <td>陈广松</td>\n",
       "      <td>4C46547278786167304458505964384147415A55744554...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>15365424002</td>\n",
       "      <td>20190918115634124045</td>\n",
       "      <td>涂书娟</td>\n",
       "      <td>4C66374952304E2F7A56634A58694D394B514C59463362...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>789</td>\n",
       "      <td>36.0</td>\n",
       "      <td>T</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>789.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>13645168615</td>\n",
       "      <td>20190918122833125725</td>\n",
       "      <td>严雪庆</td>\n",
       "      <td>3056363131706E30566138743068573232422B59383168...</td>\n",
       "      <td>命中百融黑名单</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>575.0</td>\n",
       "      <td>3</td>\n",
       "      <td>命中百融黑名单</td>\n",
       "      <td>南京市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>15288763655</td>\n",
       "      <td>20190918120355124478</td>\n",
       "      <td>从品光</td>\n",
       "      <td>7233483358584531524C682B583131474E4C6258593266...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>M</td>\n",
       "      <td>125.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杭州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>15320283661</td>\n",
       "      <td>20190918103309118165</td>\n",
       "      <td>陈胜华</td>\n",
       "      <td>4A7751353650622F3334485A7A6C494832537A4144366E...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>677</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>160.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>677.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>15365932769</td>\n",
       "      <td>20190918104635119193</td>\n",
       "      <td>杨相金</td>\n",
       "      <td>7931336D4D2F503958372B664C4E7250436F526A527459...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>721</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>721.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>13665129796</td>\n",
       "      <td>20190918091539114308</td>\n",
       "      <td>徐桂帮</td>\n",
       "      <td>4950646343317168764836517537634D6E3964442F454D...</td>\n",
       "      <td>人工归档</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>人工归档</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>13658164299</td>\n",
       "      <td>20190918113322122485</td>\n",
       "      <td>赵姗姗</td>\n",
       "      <td>31334A67467867346F7036766866674C7131535A6C6444...</td>\n",
       "      <td>年龄不匹配</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>年龄不匹配</td>\n",
       "      <td>成都市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>17323850746</td>\n",
       "      <td>20190918110849120766</td>\n",
       "      <td>蒋祖菊</td>\n",
       "      <td>6B2F5666416270626846614D536C586E6443654559756A...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>18182372566</td>\n",
       "      <td>20190918112941122304</td>\n",
       "      <td>尧光兰</td>\n",
       "      <td>53626B4E444B6A6E355646465361586132796C4C39387A...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>764</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>764.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>18100171998</td>\n",
       "      <td>20190918092050114392</td>\n",
       "      <td>余嘉静</td>\n",
       "      <td>75336E6853764C4B6E6E614565462F614E496835655466...</td>\n",
       "      <td>入网时长为空，三月消费金额为空</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>662</td>\n",
       "      <td>49.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>入网时长为空，三月消费金额为空</td>\n",
       "      <td>杭州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>17726431178</td>\n",
       "      <td>20190918134534129148</td>\n",
       "      <td>朱玉仙</td>\n",
       "      <td>685756705848574C654257492F426D3078715058763366...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>644</td>\n",
       "      <td>34.0</td>\n",
       "      <td>T</td>\n",
       "      <td>35.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>644.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>成都市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>15334695025</td>\n",
       "      <td>20190918114448123284</td>\n",
       "      <td>冉仁娟</td>\n",
       "      <td>6A6B395556386151504E6634767151316C435752334750...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>850</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>850.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>13346469031</td>\n",
       "      <td>20190918105103119637</td>\n",
       "      <td>黄结冰</td>\n",
       "      <td>4D774E35694B57355A3663524154777347764B44755646...</td>\n",
       "      <td>全网入网时长不匹配</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>T</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>746.0</td>\n",
       "      <td>3</td>\n",
       "      <td>全网入网时长不匹配</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>13650364158</td>\n",
       "      <td>20190918111623121429</td>\n",
       "      <td>龙微芬</td>\n",
       "      <td>4134626E39755A6873424E51784C5168434C422F523946...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>795</td>\n",
       "      <td>30.0</td>\n",
       "      <td>M</td>\n",
       "      <td>125.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>795.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>17764873752</td>\n",
       "      <td>20190918132329128260</td>\n",
       "      <td>胡丹卿</td>\n",
       "      <td>68474F2F3257796C6D5438635757613049764E5035697A...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>15161786645</td>\n",
       "      <td>20190918082104113331</td>\n",
       "      <td>杨建军</td>\n",
       "      <td>45774B787455552F68544B5665672B3665734565493656...</td>\n",
       "      <td>人工归档</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>人工归档</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>18825188958</td>\n",
       "      <td>20190918133951129013</td>\n",
       "      <td>宗系平</td>\n",
       "      <td>395654554474677375333733686266596C59695A596E4E...</td>\n",
       "      <td>命中重庆专属策略</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>621</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>75.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>3</td>\n",
       "      <td>命中重庆专属策略</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>15156951487</td>\n",
       "      <td>20190918103246118156</td>\n",
       "      <td>周如琴</td>\n",
       "      <td>6E656E6144425645784D2B73616E776568304657365973...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>M</td>\n",
       "      <td>125.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>15050007852</td>\n",
       "      <td>20190918112330121883</td>\n",
       "      <td>郑巧玲</td>\n",
       "      <td>6F4579586854554D744A46763833427755624B6F623968...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>795</td>\n",
       "      <td>24.0</td>\n",
       "      <td>M</td>\n",
       "      <td>75.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>795.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>18933380318</td>\n",
       "      <td>20190918093000114883</td>\n",
       "      <td>姚志平</td>\n",
       "      <td>386A3566522B324B6E32736533354F3941794879486549...</td>\n",
       "      <td>命中百融黑名单</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>命中百融黑名单</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>19906735051</td>\n",
       "      <td>20190918144410132354</td>\n",
       "      <td>章海华</td>\n",
       "      <td>73374B6B6E37634B744B7A357A385564566F5531717257...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>621</td>\n",
       "      <td>49.0</td>\n",
       "      <td>T</td>\n",
       "      <td>3.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杭州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>13615112286</td>\n",
       "      <td>20190918112113121813</td>\n",
       "      <td>李胜利</td>\n",
       "      <td>482B784B66732B325A6A446F39634A47552B5A47544338...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>M</td>\n",
       "      <td>175.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>徐州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>17312298235</td>\n",
       "      <td>20190918103451118607</td>\n",
       "      <td>谢养萍</td>\n",
       "      <td>674B41536B5747776C4556507466585747795933347368...</td>\n",
       "      <td>全网入网时长不匹配</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>T</td>\n",
       "      <td>35.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>全网入网时长不匹配</td>\n",
       "      <td>南京市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>15240255652</td>\n",
       "      <td>20190918102805118039</td>\n",
       "      <td>孙玉霞</td>\n",
       "      <td>7931336D4D2F503958372B46413841306B6F36504E5537...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>25.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>18086273035</td>\n",
       "      <td>20190918122624125589</td>\n",
       "      <td>贾莉莉</td>\n",
       "      <td>424F2F4C434F5146545450577A47576F6650465A383073...</td>\n",
       "      <td>抱歉，未能从系统的比对采样照中识别出人脸</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>746</td>\n",
       "      <td>27.0</td>\n",
       "      <td>T</td>\n",
       "      <td>160.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>746.0</td>\n",
       "      <td>3</td>\n",
       "      <td>抱歉，未能从系统的比对采样照中识别出人脸</td>\n",
       "      <td>荆门市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>18052378582</td>\n",
       "      <td>20190918102818118216</td>\n",
       "      <td>高康</td>\n",
       "      <td>4C4654727878616730445636475951642F434E454D565A...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>637</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>140.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>637.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>501 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       MOBILE_NO            ACCOUNT_ID CUSTOMER_NAME  \\\n",
       "0    15351791350  20190918084526113656           雍志强   \n",
       "1    13634714237  20190918090148113883            李洁   \n",
       "2    18996059211  20190918090520114056           陈世伟   \n",
       "3    17715633993  20190918093155115069           邹红林   \n",
       "4    17758009151  20190918093528114978           施小东   \n",
       "5    18933367633  20190918093635115203           严敏强   \n",
       "6    15700118010  20190918094402115544            向东   \n",
       "7    18108084837  20190918101455117157            彭怀   \n",
       "8    18683090162  20190918102119117811           陈利金   \n",
       "9    17502520729  20190918142108130933           卞九华   \n",
       "10   18305211899  20190918143826132052            张飞   \n",
       "11   13376069955  20190918144353132343           张晓露   \n",
       "12   18842551905  20190918112358122026           赵小燕   \n",
       "13   15330338987  20190918112900122182            张望   \n",
       "14   18048335709  20190918113406122503           郭利光   \n",
       "15   19936035059  20190918114341123232           黄新雨   \n",
       "16   15145936023  20190918114719123507           陶国成   \n",
       "17   18027005790  20190918114728123512            晏松   \n",
       "18   13999904862  20190918115001123663            罗荣   \n",
       "19   13464174933  20190918120330124469           牛佳音   \n",
       "20   15895974126  20190918120440124666           胡春梅   \n",
       "21   15927391923  20190918123923126292           高玉红   \n",
       "22   17351890057  20190918124703126647           胡楚成   \n",
       "23   16602766657  20190918124729126801            李鹏   \n",
       "24   17362934229  20190918125354126795            李磊   \n",
       "25   13914885625  20190918130906127693            毛恒   \n",
       "26   18064049355  20190918130940127537           黄小东   \n",
       "27   18651609002  20190918132450128466            陈甜   \n",
       "28   18182288490  20190918133416128872           李中杨   \n",
       "29   13771093789  20190918134052129223           杨世威   \n",
       "..           ...                   ...           ...   \n",
       "471  17318278065  20190918111853121706           朱才敏   \n",
       "472  15251492958  20190918094919115913           张芹莉   \n",
       "473  17764582897  20190918123559126118           付鑫武   \n",
       "474  17372946662  20190918143456131876           陈广松   \n",
       "475  15365424002  20190918115634124045           涂书娟   \n",
       "476  13645168615  20190918122833125725           严雪庆   \n",
       "477  15288763655  20190918120355124478           从品光   \n",
       "478  15320283661  20190918103309118165           陈胜华   \n",
       "479  15365932769  20190918104635119193           杨相金   \n",
       "480  13665129796  20190918091539114308           徐桂帮   \n",
       "481  13658164299  20190918113322122485           赵姗姗   \n",
       "482  17323850746  20190918110849120766           蒋祖菊   \n",
       "483  18182372566  20190918112941122304           尧光兰   \n",
       "484  18100171998  20190918092050114392           余嘉静   \n",
       "485  17726431178  20190918134534129148           朱玉仙   \n",
       "486  15334695025  20190918114448123284           冉仁娟   \n",
       "487  13346469031  20190918105103119637           黄结冰   \n",
       "488  13650364158  20190918111623121429           龙微芬   \n",
       "489  17764873752  20190918132329128260           胡丹卿   \n",
       "490  15161786645  20190918082104113331           杨建军   \n",
       "491  18825188958  20190918133951129013           宗系平   \n",
       "492  15156951487  20190918103246118156           周如琴   \n",
       "493  15050007852  20190918112330121883           郑巧玲   \n",
       "494  18933380318  20190918093000114883           姚志平   \n",
       "495  19906735051  20190918144410132354           章海华   \n",
       "496  13615112286  20190918112113121813           李胜利   \n",
       "497  17312298235  20190918103451118607           谢养萍   \n",
       "498  15240255652  20190918102805118039           孙玉霞   \n",
       "499  18086273035  20190918122624125589           贾莉莉   \n",
       "500  18052378582  20190918102818118216            高康   \n",
       "\n",
       "                                    CERT_NO_CIPHERTEXT  \\\n",
       "0    3632694963464569762F5738433541353256524D457A64...   \n",
       "1    31394457767032574A65444536373847324D564A304266...   \n",
       "2    67594C3344747044715A59733254327264656844614679...   \n",
       "3    2F477158775448774A4276526647387173346761487454...   \n",
       "4    776B424F55554D4A55582F5349753136456D7056365831...   \n",
       "5    4D774E35694B57355A36656B32613152512B2F3632366B...   \n",
       "6    704361552F2B376854746C336A326D6953705346347865...   \n",
       "7    7A70336E5553474D4B59677677573669663569424D2B4D...   \n",
       "8    7848506E41304B7359553355584E77552B5534396C7551...   \n",
       "9    6C78656738726D6534306D6E426C55737A6777754D6145...   \n",
       "10   482B784B66732B325A6A44567A626B3759524F596B3578...   \n",
       "11   6E6774556A2B483754713269424F597939414974397935...   \n",
       "12   596243434467516B392B7161586D55513030736C577770...   \n",
       "13   2B374F6D4B7268624557632B5737746438776D6E6C2F2F...   \n",
       "14   7442496B5752552F6974335130355A4E6D32634132764D...   \n",
       "15   35573378486D37696F684B6F774849566173622B77746D...   \n",
       "16   473945594B4A2B34356C6A524E362F647772384A316238...   \n",
       "17   50513675545037366F59417232392B70356F4637376C47...   \n",
       "18   31344172347243416A63587A45547243636E6E342F5666...   \n",
       "19   502F6D4D5054595975482F6A636F7A5A6D2F5A6F4D4C73...   \n",
       "20   757073386C5965502F5957614447534F4B30686B52754F...   \n",
       "21   356F51456B6874455A49494F6D416F4755616337336543...   \n",
       "22   3632694963464569762F5734492F69466879436266656E...   \n",
       "23   39565455447467737533342F4B385047677A6868737874...   \n",
       "24   426B636A687A676963455769554166536974614D726676...   \n",
       "25   757073386C5965502F5955447964467542627165724C36...   \n",
       "26   6F766E6548796C6A324B7167646145463555754E646256...   \n",
       "27   73614C74534D6E6B672F516F4F4A566169785834453955...   \n",
       "28   4E504E65425A75636C655458462B545264675233495170...   \n",
       "29   543338646E54674D31746E57436541726E4A3931745332...   \n",
       "..                                                 ...   \n",
       "471  584957376F41566932333075786452753047465754567A...   \n",
       "472  43596C6C4E5845336E6A6356744F75773373463553332F...   \n",
       "473  6137587A4A422B697574763643675963436A61434B7632...   \n",
       "474  4C46547278786167304458505964384147415A55744554...   \n",
       "475  4C66374952304E2F7A56634A58694D394B514C59463362...   \n",
       "476  3056363131706E30566138743068573232422B59383168...   \n",
       "477  7233483358584531524C682B583131474E4C6258593266...   \n",
       "478  4A7751353650622F3334485A7A6C494832537A4144366E...   \n",
       "479  7931336D4D2F503958372B664C4E7250436F526A527459...   \n",
       "480  4950646343317168764836517537634D6E3964442F454D...   \n",
       "481  31334A67467867346F7036766866674C7131535A6C6444...   \n",
       "482  6B2F5666416270626846614D536C586E6443654559756A...   \n",
       "483  53626B4E444B6A6E355646465361586132796C4C39387A...   \n",
       "484  75336E6853764C4B6E6E614565462F614E496835655466...   \n",
       "485  685756705848574C654257492F426D3078715058763366...   \n",
       "486  6A6B395556386151504E6634767151316C435752334750...   \n",
       "487  4D774E35694B57355A3663524154777347764B44755646...   \n",
       "488  4134626E39755A6873424E51784C5168434C422F523946...   \n",
       "489  68474F2F3257796C6D5438635757613049764E5035697A...   \n",
       "490  45774B787455552F68544B5665672B3665734565493656...   \n",
       "491  395654554474677375333733686266596C59695A596E4E...   \n",
       "492  6E656E6144425645784D2B73616E776568304657365973...   \n",
       "493  6F4579586854554D744A46763833427755624B6F623968...   \n",
       "494  386A3566522B324B6E32736533354F3941794879486549...   \n",
       "495  73374B6B6E37634B744B7A357A385564566F5531717257...   \n",
       "496  482B784B66732B325A6A446F39634A47552B5A47544338...   \n",
       "497  674B41536B5747776C4556507466585747795933347368...   \n",
       "498  7931336D4D2F503958372B46413841306B6F36504E5537...   \n",
       "499  424F2F4C434F5146545450577A47576F6650465A383073...   \n",
       "500  4C4654727878616730445636475951642F434E454D565A...   \n",
       "\n",
       "                                           征信表拒绝原因   STATUS  ZIYINGB_SCORE  \\\n",
       "0                                              NaN  SUCCESS            580   \n",
       "1                                              NaN  SUCCESS            619   \n",
       "2                                        自营分不符合最小值     FAIL            482   \n",
       "3                                              NaN  SUCCESS            594   \n",
       "4                                              NaN  SUCCESS            464   \n",
       "5                                              NaN  SUCCESS            586   \n",
       "6                                              NaN  SUCCESS            555   \n",
       "7                                              NaN  SUCCESS            536   \n",
       "8    运营商为联通且身份证关联的邮箱个数大于等于0且1个月内在非银机构新增核准借贷次数大于等于1     FAIL              0   \n",
       "9                                              NaN  SUCCESS            554   \n",
       "10                                             NaN  SUCCESS            616   \n",
       "11                                 入网时长为空，三月消费金额为空     FAIL            655   \n",
       "12                                             NaN  SUCCESS            497   \n",
       "13                                       自营分不符合最小值     FAIL            581   \n",
       "14                                             NaN  SUCCESS            553   \n",
       "15                                       自营分不符合最小值     FAIL            579   \n",
       "16                                       自营分不符合最小值     FAIL            529   \n",
       "17                                       自营分不符合最小值     FAIL            560   \n",
       "18                                             NaN  SUCCESS            683   \n",
       "19                                             NaN  SUCCESS            551   \n",
       "20                                             NaN  SUCCESS            749   \n",
       "21                                          人脸比对失败     FAIL            551   \n",
       "22                                             NaN  SUCCESS            553   \n",
       "23                                             NaN  SUCCESS            563   \n",
       "24                                             NaN  SUCCESS            519   \n",
       "25                                             NaN  SUCCESS            403   \n",
       "26                                             NaN  SUCCESS            441   \n",
       "27                                             NaN  SUCCESS            735   \n",
       "28                                       自营分不符合最小值     FAIL            519   \n",
       "29                                       自营分不符合最小值     FAIL            539   \n",
       "..                                             ...      ...            ...   \n",
       "471                                            NaN  SUCCESS              0   \n",
       "472                                            NaN  SUCCESS              0   \n",
       "473                                            NaN  SUCCESS            621   \n",
       "474                                            NaN  SUCCESS              0   \n",
       "475                                            NaN  SUCCESS            789   \n",
       "476                                        命中百融黑名单     FAIL              0   \n",
       "477                                            NaN  SUCCESS              0   \n",
       "478                                            NaN  SUCCESS            677   \n",
       "479                                            NaN  SUCCESS            721   \n",
       "480                                           人工归档     FAIL              0   \n",
       "481                                          年龄不匹配     FAIL              0   \n",
       "482                                            NaN  SUCCESS              0   \n",
       "483                                            NaN  SUCCESS            764   \n",
       "484                                入网时长为空，三月消费金额为空     FAIL            662   \n",
       "485                                            NaN  SUCCESS            644   \n",
       "486                                            NaN  SUCCESS            850   \n",
       "487                                      全网入网时长不匹配     FAIL              0   \n",
       "488                                            NaN  SUCCESS            795   \n",
       "489                                            NaN  SUCCESS              0   \n",
       "490                                           人工归档     FAIL              0   \n",
       "491                                       命中重庆专属策略     FAIL            621   \n",
       "492                                            NaN  SUCCESS              0   \n",
       "493                                            NaN  SUCCESS            795   \n",
       "494                                        命中百融黑名单     FAIL              0   \n",
       "495                                            NaN  SUCCESS            621   \n",
       "496                                            NaN  SUCCESS              0   \n",
       "497                                      全网入网时长不匹配     FAIL              0   \n",
       "498                                            NaN  SUCCESS              0   \n",
       "499                           抱歉，未能从系统的比对采样照中识别出人脸     FAIL            746   \n",
       "500                                            NaN  SUCCESS            637   \n",
       "\n",
       "      腾讯分  运营商   三月消费  入网时长    百融分  授信状态  \\\n",
       "0     NaN    T   35.0  24.0  580.0     2   \n",
       "1    56.0    M  175.0  99.0  619.0     2   \n",
       "2     NaN    T  140.0  99.0  482.0     3   \n",
       "3     NaN    T  160.0  24.0  594.0     2   \n",
       "4    39.0    T   20.0  99.0  464.0     2   \n",
       "5    24.0    T  140.0  99.0  586.0     2   \n",
       "6    32.0    M  175.0  99.0  555.0     2   \n",
       "7    20.0    T  160.0  99.0  536.0     2   \n",
       "8    24.0    U  120.0  99.0  491.0     3   \n",
       "9    26.0    U  120.0  99.0  554.0     2   \n",
       "10   26.0    M  225.0  99.0  616.0     2   \n",
       "11   58.0  NaN    NaN   NaN  655.0     3   \n",
       "12   22.0    M  225.0  99.0  497.0     2   \n",
       "13    NaN    T  160.0  24.0  581.0     3   \n",
       "14   56.0    T  100.0  99.0  553.0     2   \n",
       "15    NaN    T  140.0  12.0  579.0     3   \n",
       "16   33.0    M   75.0  99.0  529.0     3   \n",
       "17   36.0    T  140.0  24.0  560.0     3   \n",
       "18   39.0    M  175.0  99.0  683.0     2   \n",
       "19   21.0    M   75.0  99.0  551.0     2   \n",
       "20   30.0    M  125.0  99.0  749.0     2   \n",
       "21   36.0    M  175.0  99.0  551.0     3   \n",
       "22    NaN    T   20.0  99.0  553.0     2   \n",
       "23   43.0    U  120.0  24.0  563.0     2   \n",
       "24   37.0    T  140.0  24.0  519.0     2   \n",
       "25   57.0    M  125.0  99.0  403.0     2   \n",
       "26   21.0    T   35.0  24.0  441.0     2   \n",
       "27   16.0    U  120.0  99.0  735.0     2   \n",
       "28    NaN    T    0.0  24.0  519.0     3   \n",
       "29   29.0    M  225.0  99.0  539.0     3   \n",
       "..    ...  ...    ...   ...    ...   ...   \n",
       "471   NaN    T   35.0  99.0    NaN     2   \n",
       "472  31.0    M   75.0  99.0    NaN     2   \n",
       "473  58.0    T    0.0  99.0  621.0     2   \n",
       "474   NaN    T  100.0  99.0    NaN     2   \n",
       "475  36.0    T  100.0  99.0  789.0     2   \n",
       "476  31.0  NaN    NaN   NaN  575.0     3   \n",
       "477  27.0    M  125.0  99.0    NaN     2   \n",
       "478   NaN    T  160.0  99.0  677.0     2   \n",
       "479   NaN  NaN    NaN   NaN  721.0     2   \n",
       "480  49.0  NaN    NaN   NaN    NaN     3   \n",
       "481  20.0  NaN    NaN   NaN    NaN     3   \n",
       "482   NaN    T  140.0  24.0    NaN     2   \n",
       "483   NaN    T  100.0  99.0  764.0     2   \n",
       "484  49.0  NaN    NaN   NaN    NaN     3   \n",
       "485  34.0    T   35.0  24.0  644.0     2   \n",
       "486   NaN    T  140.0  99.0  850.0     2   \n",
       "487  48.0    T    0.0   6.0  746.0     3   \n",
       "488  30.0    M  125.0  99.0  795.0     2   \n",
       "489   NaN    T  140.0  99.0    NaN     2   \n",
       "490   NaN  NaN    NaN   NaN    NaN     3   \n",
       "491   NaN    M   75.0  24.0  621.0     3   \n",
       "492  21.0    M  125.0  99.0    NaN     2   \n",
       "493  24.0    M   75.0  99.0  795.0     2   \n",
       "494  55.0  NaN    NaN   NaN    NaN     3   \n",
       "495  49.0    T    3.0  24.0  621.0     2   \n",
       "496  22.0    M  175.0  99.0    NaN     2   \n",
       "497  59.0    T   35.0   3.0    NaN     3   \n",
       "498   NaN    M   25.0  99.0    NaN     2   \n",
       "499  27.0    T  160.0  99.0  746.0     3   \n",
       "500   NaN    T  140.0  99.0  637.0     2   \n",
       "\n",
       "                                            授信拒绝原因 CITY_NAME  \n",
       "0                                              NaN       淮安市  \n",
       "1                                              NaN     呼和浩特市  \n",
       "2                                        自营分不符合最小值     重庆市辖区  \n",
       "3                                              NaN       淮安市  \n",
       "4                                              NaN       杭州市  \n",
       "5                                              NaN       中山市  \n",
       "6                                              NaN       杭州市  \n",
       "7                                              NaN       成都市  \n",
       "8    运营商为联通且身份证关联的邮箱个数大于等于0且1个月内在非银机构新增核准借贷次数大于等于1       中山市  \n",
       "9                                              NaN       南京市  \n",
       "10                                             NaN       徐州市  \n",
       "11                                 入网时长为空，三月消费金额为空       南京市  \n",
       "12                                             NaN       沈阳市  \n",
       "13                                       自营分不符合最小值     重庆市辖区  \n",
       "14                                             NaN     呼和浩特市  \n",
       "15                                       自营分不符合最小值     重庆市辖区  \n",
       "16                                       自营分不符合最小值       东莞市  \n",
       "17                                       自营分不符合最小值       东莞市  \n",
       "18                                             NaN     乌鲁木齐市  \n",
       "19                                             NaN       沈阳市  \n",
       "20                                             NaN       南京市  \n",
       "21                                          人脸比对失败       武汉市  \n",
       "22                                             NaN       淮安市  \n",
       "23                                             NaN       武汉市  \n",
       "24                                             NaN       武汉市  \n",
       "25                                             NaN       徐州市  \n",
       "26                                             NaN       武汉市  \n",
       "27                                             NaN       南京市  \n",
       "28                                       自营分不符合最小值     重庆市辖区  \n",
       "29                                       自营分不符合最小值       无锡市  \n",
       "..                                             ...       ...  \n",
       "471                                            NaN     重庆市辖区  \n",
       "472                                            NaN       徐州市  \n",
       "473                                            NaN       杭州市  \n",
       "474                                            NaN       淮安市  \n",
       "475                                            NaN       徐州市  \n",
       "476                                        命中百融黑名单       南京市  \n",
       "477                                            NaN       杭州市  \n",
       "478                                            NaN     重庆市辖区  \n",
       "479                                            NaN       淮安市  \n",
       "480                                           人工归档       无锡市  \n",
       "481                                          年龄不匹配       成都市  \n",
       "482                                            NaN     重庆市辖区  \n",
       "483                                            NaN     重庆市辖区  \n",
       "484                                入网时长为空，三月消费金额为空       杭州市  \n",
       "485                                            NaN       成都市  \n",
       "486                                            NaN     重庆市辖区  \n",
       "487                                      全网入网时长不匹配       中山市  \n",
       "488                                            NaN       东莞市  \n",
       "489                                            NaN     重庆市辖区  \n",
       "490                                           人工归档       淮安市  \n",
       "491                                       命中重庆专属策略     重庆市辖区  \n",
       "492                                            NaN       无锡市  \n",
       "493                                            NaN       徐州市  \n",
       "494                                        命中百融黑名单       中山市  \n",
       "495                                            NaN       杭州市  \n",
       "496                                            NaN       徐州市  \n",
       "497                                      全网入网时长不匹配       南京市  \n",
       "498                                            NaN       淮安市  \n",
       "499                           抱歉，未能从系统的比对采样照中识别出人脸       荆门市  \n",
       "500                                            NaN       淮安市  \n",
       "\n",
       "[501 rows x 15 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 导入百融csv文件\n",
    "import pandas as pd\n",
    "import os\n",
    "os.chdir('D:\\百融去重处理')\n",
    "br = pd.read_csv('jujue.csv',low_memory=False)\n",
    "br"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-18T06:58:39.813653Z",
     "start_time": "2019-09-18T06:58:39.808663Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['MOBILE_NO',\n",
       " 'ACCOUNT_ID',\n",
       " 'CUSTOMER_NAME',\n",
       " 'CERT_NO_CIPHERTEXT',\n",
       " '征信表拒绝原因',\n",
       " 'STATUS',\n",
       " 'ZIYINGB_SCORE',\n",
       " '腾讯分',\n",
       " '运营商',\n",
       " '三月消费',\n",
       " '入网时长',\n",
       " '百融分',\n",
       " '授信状态',\n",
       " '授信拒绝原因',\n",
       " 'CITY_NAME']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(br)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-18T07:06:40.558381Z",
     "start_time": "2019-09-18T07:06:40.472605Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Success!\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# br=pd.read_csv('bairong912.csv',low_memory=False)\n",
    "# br\n",
    "# 查看列名\n",
    "# br.columns\n",
    "\n",
    "# 根据指定列名取出重复行并查看\n",
    "#br_duplicated = br[br.duplicated('CERT_NO_CIPHERTEXT',keep=False)]\n",
    "# 排序\n",
    "#br_duplicated_sort = br_duplicated.sort_values(['REQUEST_DATE'],ascending=0,inplace=False)\n",
    "# br_duplicated_sort\n",
    "\n",
    "# br_duplicated_sort.groupby(['CERT_NO_CIPHERTEXT','CUSTOMER_NAME']).count().sort_values(['ACCOUNT_ID'],ascending=0)\n",
    "# br_duplicated_sort.loc[br_duplicated_sort['STATUS']=='SUCCESS']\n",
    "\n",
    "# 把数据分为成功和失败\n",
    "success = br[br['STATUS']=='SUCCESS']\n",
    "fail    = br[br['STATUS']=='FAIL']\n",
    "\n",
    "# 处理成功部分\n",
    "success_sort = success.sort_values(['MOBILE_NO'],ascending=[0],inplace=False)\n",
    "# 删除重复项，保留重复项第一行\n",
    "success_last = success_sort.drop_duplicates(subset=['MOBILE_NO'],keep='first',inplace=False)\n",
    "\n",
    "\n",
    "# 处理失败部分\n",
    "fail_sort = fail.sort_values(['MOBILE_NO'],ascending=[0],inplace=False)\n",
    "# 删除重复项，保留重复项第一行\n",
    "fail_last = fail_sort.drop_duplicates(subset=['MOBILE_NO'],keep='first',inplace=False)\n",
    "\n",
    "# 合并得到重复行只有一个成功一个失败（取成功的）\n",
    "different = pd.concat([success_last,fail_last])\n",
    "different_sort = different.sort_values(['MOBILE_NO','STATUS'],ascending=[0,0],inplace=False)\n",
    "# 删除重复项，保留重复项第一行(status为success) (根据status排序，success在上面)\n",
    "br_last  = different_sort.drop_duplicates(subset=['MOBILE_NO'],keep='first',inplace=False)\n",
    "br_last1 = br_last[br_last.征信表拒绝原因!='人工归档']\n",
    "br_last1.to_csv('拒绝原因.csv',encoding='utf_8_sig',index=False)\n",
    "print('Success!')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
